package cn.java666.SZTsparkhive

import org.apache.spark.sql.SparkSession
import org.junit.Test
/**
 * @author Geek
 * @date 2020-04-21 02:22:40
 *
 * spark on hive 
 * spark 操作 远程 hive 数据库
 *
 */
case class SparkOnHive() {
	val spark = SparkSession.builder()
		.master("local[*]")
		.appName("SparkOnHive")
		.enableHiveSupport()
		.config("spark.driver.host", "lx")
		.getOrCreate()
	
	import spark.implicits._
	import spark.sql
	
	@Test
	def testSqls() {
		val sqls =
			"""
				|show databases;
				|show tables in szt;
				|use szt;
				|select * from ads_card_deal_day_top;
				|select * from ads_in_out_station_day_top;
				|select * from ads_in_station_day_top;
				|select * from ads_line_send_passengers_day_top;
				|select * from ads_out_station_day_top;
				|
				|""".stripMargin
		val sql_arr = sqls.split(";")
		
		sql_arr.foreach(x => {
			if (x.trim.nonEmpty) {
				sql(x).show(10, 50) // sql 太大，一屏放不下🙄🙄🙄
			}
		})
		
		spark.stop
	}
	
	
	@Test //不推荐此方式提交 
	def testYarn() {
		val spark = SparkSession.builder()
			
			//Detected yarn cluster mode, but isn't running on a cluster. Deployment to YARN is not supported directly by SparkContext. Please use spark-submit.
			//.master("yarn-cluster")
			
			//Detected yarn cluster mode, but isn't running on a cluster. Deployment to YARN is not supported directly by SparkContext. Please use spark-submit.
			//https://github.com/apache/spark/blob/master/docs/configuration.md
			//.config("spark.submit.deployMode", "cluster")
			
			//spark.sql.catalyst.expressions.AttributeReference; local class incompatible: stream classdesc serialVersionUID ???
			
			.master("yarn")
			.appName("App1")
			//.config("spark.jars", "target/SZT-spark-hive-0.1-jar-with-dependencies.jar")
			.config("spark.jars", "target/SZT-spark-hive-0.1.jar")
			.config("spark.driver.host", "lx") // 多网卡机器，会识别到错误的主机名，要写绝对地址，不要 localhost
			.enableHiveSupport()
			.getOrCreate()
		
		spark.sparkContext.setLogLevel("warn")
		import spark.sql
		
		sql("show databases")
			.show(100, false)
		//|select * from test_score
		//show databases
		
		// 因为 HDFS 采用 LZO 压缩，spark 读取 HDFS 需要配置相应的 LZO 依赖，客户端也需要 LZO 环境，均要保证版本号兼容，lzo 项目年久失修，找不到匹配的版本了，所以 yarn 远程提交无法解码压缩文件 HDFS，建议取消压缩
		
		spark.stop
	}
	
	/*
	+------------+
	|databaseName|
	+------------+
	|default     |
	|szt         |
	+------------+
	*/
	
	@Test //ok 
	def testLocal() {
		val spark = SparkSession.builder()
			.master("local[*]")
			.appName("AppLocal2")
			.config("spark.driver.host", "lx") // 多网卡机器，会识别到错误的主机名，要写绝对地址，不要 localhost
			.enableHiveSupport()
			.getOrCreate()
		
		//spark.sparkContext.setLogLevel("warn")
		import spark.sql
		
		//hdfs 启用 LZO 压缩以后，需要在客户端添加 LZO 依赖库的环境变量和 maven 坐标，windows本地配置lzo读取所需相关组件_运维_coolerzZ的博客-CSDN博客 https://blog.csdn.net/coolerzz/article/details/103952188
		sql(
			"""
				|select * from szt.ods_szt_data limit 100
				|""".stripMargin)
			.show(200, false)
		
		spark.stop()
	}
}

/*

+------------+
|databaseName|
+------------+
|     default|
|         szt|
+------------+

+--------+--------------------------------+-----------+
|database|                       tableName|isTemporary|
+--------+--------------------------------+-----------+
|     szt|           ads_card_deal_day_top|      false|
|     szt|      ads_in_out_station_day_top|      false|
|     szt|          ads_in_station_day_top|      false|
|     szt|ads_line_send_passengers_day_top|      false|
|     szt|         ads_out_station_day_top|      false|
|     szt|          dwd_fact_szt_in_detail|      false|
|     szt|      dwd_fact_szt_in_out_detail|      false|
|     szt|         dwd_fact_szt_out_detail|      false|
|     szt|        dws_card_record_day_wide|      false|
|     szt|                    ods_szt_data|      false|
+--------+--------------------------------+-----------+

++
||
++
++

20/04/22 00:46:02 WARN conf.HiveConf: HiveConf of name hive.vectorized.use.checked.expressions does not exist
20/04/22 00:46:02 WARN conf.HiveConf: HiveConf of name hive.strict.checks.no.partition.filter does not exist
20/04/22 00:46:02 WARN conf.HiveConf: HiveConf of name hive.vectorized.use.vector.serde.deserialize does not exist
20/04/22 00:46:02 WARN conf.HiveConf: HiveConf of name hive.strict.checks.orderby.no.limit does not exist
20/04/22 00:46:02 WARN conf.HiveConf: HiveConf of name hive.vectorized.adaptor.usage.mode does not exist
20/04/22 00:46:02 WARN conf.HiveConf: HiveConf of name hive.vectorized.use.vectorized.input.format does not exist
20/04/22 00:46:02 WARN conf.HiveConf: HiveConf of name hive.vectorized.input.format.excludes does not exist
20/04/22 00:46:02 WARN conf.HiveConf: HiveConf of name hive.strict.checks.bucketing does not exist
20/04/22 00:46:02 WARN conf.HiveConf: HiveConf of name hive.strict.checks.type.safety does not exist
20/04/22 00:46:02 WARN conf.HiveConf: HiveConf of name hive.strict.checks.cartesian.product does not exist
+---------+------------------------------------------------------------------------------------+--------+----------------------------------------------------+----------------------------+-------------+----------+--------------------------------------------+-----+----------+
|  card_no|                                                                       deal_date_arr|deal_sum|                                    company_name_arr|                 station_arr|conn_mark_arr|deal_m_sum|                                  equ_no_arr|count|       day|
+---------+------------------------------------------------------------------------------------+--------+----------------------------------------------------+----------------------------+-------------+----------+--------------------------------------------+-----+----------+
|FHIGEIEDB|[2018-09-01 06:46:59, 2018-09-01 08:37:48, 2018-09-01 07:45:43, 2018-09-01 07:43:59]|  4800.0|[地铁十一号线, 地铁十一号线, 地铁三号线, 地铁三号线]|[福永站, 福永站, 益田, 益田]| [0, 0, 0, 0]|    4800.0|[241021107, 241021103, 261003110, 261003103]|    4|2018-09-01|
|FHIGEIEDB|[2018-09-01 06:46:59, 2018-09-01 08:37:48, 2018-09-01 07:45:43, 2018-09-01 07:43:59]|  4800.0|[地铁十一号线, 地铁十一号线, 地铁三号线, 地铁三号线]|[福永站, 福永站, 益田, 益田]| [0, 0, 0, 0]|    4800.0|[241021107, 241021103, 261003110, 261003103]|    4|2018-09-01|
|FHIGEIEDB|[2018-09-01 06:46:59, 2018-09-01 08:37:48, 2018-09-01 07:45:43, 2018-09-01 07:43:59]|  4800.0|[地铁十一号线, 地铁十一号线, 地铁三号线, 地铁三号线]|[福永站, 福永站, 益田, 益田]| [0, 0, 0, 0]|    4800.0|[241021107, 241021103, 261003110, 261003103]|    4|2018-09-01|
|FHIGEIEDB|[2018-09-01 06:46:59, 2018-09-01 08:37:48, 2018-09-01 07:45:43, 2018-09-01 07:43:59]|  4800.0|[地铁十一号线, 地铁十一号线, 地铁三号线, 地铁三号线]|[福永站, 福永站, 益田, 益田]| [0, 0, 0, 0]|    4800.0|[241021107, 241021103, 261003110, 261003103]|    4|2018-09-01|
|FHIGEIEDB|[2018-09-01 06:46:59, 2018-09-01 08:37:48, 2018-09-01 07:45:43, 2018-09-01 07:43:59]|  4800.0|[地铁十一号线, 地铁十一号线, 地铁三号线, 地铁三号线]|[福永站, 福永站, 益田, 益田]| [0, 0, 0, 0]|    4800.0|[241021107, 241021103, 261003110, 261003103]|    4|2018-09-01|
|FHIGEIEDB|[2018-09-01 06:46:59, 2018-09-01 08:37:48, 2018-09-01 07:45:43, 2018-09-01 07:43:59]|  4800.0|[地铁十一号线, 地铁十一号线, 地铁三号线, 地铁三号线]|[福永站, 福永站, 益田, 益田]| [0, 0, 0, 0]|    4800.0|[241021107, 241021103, 261003110, 261003103]|    4|2018-09-01|
|FHIGEIEDB|[2018-09-01 06:46:59, 2018-09-01 08:37:48, 2018-09-01 07:45:43, 2018-09-01 07:43:59]|  4800.0|[地铁十一号线, 地铁十一号线, 地铁三号线, 地铁三号线]|[福永站, 福永站, 益田, 益田]| [0, 0, 0, 0]|    4800.0|[241021107, 241021103, 261003110, 261003103]|    4|2018-09-01|
|FHIGEIEDB|[2018-09-01 06:46:59, 2018-09-01 08:37:48, 2018-09-01 07:45:43, 2018-09-01 07:43:59]|  4800.0|[地铁十一号线, 地铁十一号线, 地铁三号线, 地铁三号线]|[福永站, 福永站, 益田, 益田]| [0, 0, 0, 0]|    4800.0|[241021107, 241021103, 261003110, 261003103]|    4|2018-09-01|
|FHIGEIEDB|[2018-09-01 06:46:59, 2018-09-01 08:37:48, 2018-09-01 07:45:43, 2018-09-01 07:43:59]|  4800.0|[地铁十一号线, 地铁十一号线, 地铁三号线, 地铁三号线]|[福永站, 福永站, 益田, 益田]| [0, 0, 0, 0]|    4800.0|[241021107, 241021103, 261003110, 261003103]|    4|2018-09-01|
|FHIGEIEDB|[2018-09-01 06:46:59, 2018-09-01 08:37:48, 2018-09-01 07:45:43, 2018-09-01 07:43:59]|  4800.0|[地铁十一号线, 地铁十一号线, 地铁三号线, 地铁三号线]|[福永站, 福永站, 益田, 益田]| [0, 0, 0, 0]|    4800.0|[241021107, 241021103, 261003110, 261003103]|    4|2018-09-01|
+---------+------------------------------------------------------------------------------------+--------+----------------------------------------------------+----------------------------+-------------+----------+--------------------------------------------+-----+----------+
only showing top 10 rows

+-------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+-----+----------+
|station|                                                                                       deal_date_arr|                                                                                         card_no_arr|                                                                                      deal_value_arr|                                                                                                                                                       deal_type_arr|                                                                                                                                                            company_name_arr|                                                                                       conn_mark_arr|                                                                                      deal_money_arr|                                                                                          equ_no_arr|count|       day|
+-------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+-----+----------+
|   五和|[2018-09-01 06:14:19, 2018-09-01 06:14:45, 2018-09-01 06:14:53, 2018-09-01 06:14:57, 2018-09-01 0...|[CBGEBCEEE, FIJAEGCJG, FHIEHFHGJ, FHHCEFFJE, BBJBABJI, FFEEACHIF, FHDCCIFIB, BHEADDEIH, CBGJIGJBI...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 200, 0, 200, 0, 0, 0, 0, 0, 0, 0, 0, 0,...|[地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, ...|  [地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 190, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0...|[263026121, 263026115, 263026111, 263026121, 263026120, 263026120, 263026111, 263026111, 26302611...|16417|2018-09-01|
|   布吉|[2018-09-01 06:18:57, 2018-09-01 06:19:10, 2018-09-01 06:19:13, 2018-09-01 06:19:14, 2018-09-01 0...|[FFAEJDDCH, FHDIHADJI, FHDBFDDBE, CBFBHABAC, CCAFDJJAF, BIFAGGIED, BCDGGIIA, FFGCJBEGF, FHGCHEGGJ...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, ...|  [地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁三号线, 地铁三号线, 地铁三号线...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[263032104, 263032105, 263032105, 263032103, 263032105, 263032105, 263032105, 263032105, 26303210...|14369|2018-09-01|
| 罗湖站|[2018-09-01 06:15:13, 2018-09-01 06:19:10, 2018-09-01 06:19:17, 2018-09-01 06:19:25, 2018-09-01 0...|[HHAAABGEI, FHHCCAGCJ, FHGIFFBGJ, CFHCDGDEH, FHDIIBFBG, FHHGAJJJJ, FHDBGADAJ, FFEFEHCJA, CBIBCIFH...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, ...|  [地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[268001112, 268001138, 268001138, 268001140, 268001136, 268001138, 268001137, 268001138, 26800113...|14182|2018-09-01|
| 深圳北|[2018-09-01 06:20:34, 2018-09-01 06:20:38, 2018-09-01 06:20:39, 2018-09-01 06:20:48, 2018-09-01 0...|[FHHCEGIHD, CFBBDAGCC, CBGBBAEBI, FFIJGAFDA, CFAAHEIFE, CFHBDHAHG, CBJHFAJHH, CCJHBEJFH, BICECDDC...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, ...|  [地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[263024131, 263024133, 263024134, 263024132, 263024134, 263024101, 263024102, 263024101, 26302410...|13718|2018-09-01|
|   民治|[2018-09-01 06:15:56, 2018-09-01 06:16:05, 2018-09-01 06:16:23, 2018-09-01 06:16:40, 2018-09-01 0...|[CBGJJBJAD, DDABCJBGE, BIBIJFHCB, FHEGBCHDF, FHEICEICJ, BIDFEEEDB, FHDEAHICB, CFHBFACAF, FIJDBAFD...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, ...|  [地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[263025115, 263025115, 263025113, 263025115, 263025106, 263025106, 263025114, 263025115, 26302511...|12475|2018-09-01|
| 丹竹头|[2018-09-01 06:17:11, 2018-09-01 06:19:14, 2018-09-01 06:19:16, 2018-09-01 06:19:22, 2018-09-01 0...|[HHAAAAJJH, BIJGDBGJH, FHHFCGCEJ, FHDFCFBAJ, FHIGEHIHA, CFBEHCIED, FHFHJCHGB, CBCCEBJFB, CFADGHAC...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, ...|  [地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[261021102, 261021117, 261021102, 261021102, 261021103, 261021116, 261021116, 261021103, 26102111...|11291|2018-09-01|
|   龙华|[2018-09-01 06:15:58, 2018-09-01 06:16:04, 2018-09-01 06:16:20, 2018-09-01 06:16:56, 2018-09-01 0...|[CFAFCEBBE, CFHBAJFFA, BEBAJFJJJ, CFHJFJEJJ, CBHFFDBDA, FHGADIIAA, CFHCEBFBD, FHICJGBIA, BJHHIAED...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, ...|  [地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[262012105, 262012105, 262012118, 262012111, 262012112, 262012111, 262012111, 262012111, 26201210...|11082|2018-09-01|
|   清湖|[2018-09-01 06:14:18, 2018-09-01 06:14:28, 2018-09-01 06:14:50, 2018-09-01 06:15:16, 2018-09-01 0...|[FIJCJAIAA, FFAEJIJFF, FFHDHGDJF, FHIGDICBI, CBJDEJJAD, FHDDHDCGJ, CFHDJFEFG, FIAFEGHGJ, CFHDHAAD...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, ...|  [地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[262011106, 262011104, 262011103, 262011104, 262011104, 262011106, 262011105, 262011106, 26201110...|10511|2018-09-01|
| 南山站|[2018-09-01 06:14:07, 2018-09-01 06:14:18, 2018-09-01 06:15:23, 2018-09-01 06:15:39, 2018-09-01 0...|[FIBAHEDHA, BEBJBGGCG, HHJJAEIGB, HHAAACCJB, FHIHHJJGC, FHIHBACEI, FFGDDIBGJ, CBCHHACBI, FIACIJDI...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 200, 200, 0, 0, 0, 200, 0, 200, 200, 200, 0, 0, 0, 0, 0, ...|[地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁出站, 地铁出站, 地铁入站, ...|[地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, ...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 190, 0, 190, 190, 190, 0, 0, 0, 0, 0, 0, 0...|[241015127, 241015129, 241015128, 241015109, 241015128, 241015107, 241015109, 241015109, 24101512...| 9952|2018-09-01|
| 黄贝岭|[2018-09-01 06:14:15, 2018-09-01 06:14:19, 2018-09-01 06:14:39, 2018-09-01 06:14:42, 2018-09-01 0...|[CBIGDJFFF, FFGEBGJFE, CBCJIJEGJ, CBAGHBHEH, CFAEBECAA, CBIBCGHJD, CCJHCBGEJ, CBGAEAHJI, CCJFGGEJ...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 200, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0...|[地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, 地铁入站, ...|  [地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 190, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0...|[263037118, 263037118, 263037117, 263037117, 263037110, 263037117, 263037113, 263037117, 26303711...| 9704|2018-09-01|
+-------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+-----+----------+
only showing top 10 rows

+-------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+-----+----------+
|station|                                                                                       deal_date_arr|                                                                                         card_no_arr|                                                                                                                                                          company_name_arr|                                                                                          equ_no_arr|count|       day|
+-------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+-----+----------+
|   五和|[2018-09-01 06:14:19, 2018-09-01 06:14:45, 2018-09-01 06:14:53, 2018-09-01 06:14:57, 2018-09-01 0...|[CBGEBCEEE, FIJAEGCJG, FHIEHFHGJ, FHHCEFFJE, BBJBABJI, FFEEACHIF, FHDCCIFIB, BHEADDEIH, CBGJIGJBI...|[地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线...|[263026121, 263026115, 263026111, 263026121, 263026120, 263026120, 263026111, 263026111, 26302611...|11359|2018-09-01|
|   布吉|[2018-09-01 06:18:57, 2018-09-01 06:19:10, 2018-09-01 06:19:13, 2018-09-01 06:19:14, 2018-09-01 0...|[FFAEJDDCH, FHDIHADJI, FHDBFDDBE, CBFBHABAC, CCAFDJJAF, BIFAGGIED, BCDGGIIA, FFGCJBEGF, FHGCHEGGJ...|[地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁三号线, 地铁三号线, 地铁三号线...|[263032104, 263032105, 263032105, 263032103, 263032105, 263032105, 263032105, 263032105, 26303210...| 9871|2018-09-01|
| 丹竹头|[2018-09-01 06:17:11, 2018-09-01 06:19:14, 2018-09-01 06:19:16, 2018-09-01 06:19:22, 2018-09-01 0...|[HHAAAAJJH, BIJGDBGJH, FHHFCGCEJ, FHDFCFBAJ, FHIGEHIHA, CFBEHCIED, FHFHJCHGB, CBCCEBJFB, CFADGHAC...|[地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线...|[261021102, 261021117, 261021102, 261021102, 261021103, 261021116, 261021116, 261021103, 26102111...| 8786|2018-09-01|
|   民治|[2018-09-01 06:15:56, 2018-09-01 06:16:05, 2018-09-01 06:16:23, 2018-09-01 06:16:40, 2018-09-01 0...|[CBGJJBJAD, DDABCJBGE, BIBIJFHCB, FHEGBCHDF, FHEICEICJ, BIDFEEEDB, FHDEAHICB, CFHBFACAF, FIJDBAFD...|[地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线...|[263025115, 263025115, 263025113, 263025115, 263025106, 263025106, 263025114, 263025115, 26302511...| 8733|2018-09-01|
|   龙华|[2018-09-01 06:15:58, 2018-09-01 06:16:04, 2018-09-01 06:16:20, 2018-09-01 06:16:56, 2018-09-01 0...|[CFAFCEBBE, CFHBAJFFA, BEBAJFJJJ, CFHJFJEJJ, CBHFFDBDA, FHGADIIAA, CFHCEBFBD, FHICJGBIA, BJHHIAED...|[地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线...|[262012105, 262012105, 262012118, 262012111, 262012112, 262012111, 262012111, 262012111, 26201210...| 7901|2018-09-01|
|   清湖|[2018-09-01 06:14:18, 2018-09-01 06:14:28, 2018-09-01 06:14:50, 2018-09-01 06:15:16, 2018-09-01 0...|[FIJCJAIAA, FFAEJIJFF, FFHDHGDJF, FHIGDICBI, CBJDEJJAD, FHDDHDCGJ, CFHDJFEFG, FIAFEGHGJ, CFHDHAAD...|[地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线...|[262011106, 262011104, 262011103, 262011104, 262011104, 262011106, 262011105, 262011106, 26201110...| 7619|2018-09-01|
| 下水径|[2018-09-01 06:15:34, 2018-09-01 06:15:39, 2018-09-01 06:16:19, 2018-09-01 06:16:57, 2018-09-01 0...|[FHIBCFCAA, CBFIBDAFA, FHFJDHGDJ, FHJAGEIGD, BEBJIJBBI, CFDJJEAJI, BIFBHBAAA, FHHEBIAIF, FFGBJBHJ...|[地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线...|[263030115, 263030117, 263030117, 263030116, 263030116, 263030117, 263030117, 263030117, 26303011...| 6697|2018-09-01|
|   固戍|[2018-09-01 06:14:32, 2018-09-01 06:19:51, 2018-09-01 06:20:00, 2018-09-01 06:20:12, 2018-09-01 0...|[HHAAACDJH, FHGJBHDBC, FFJDJIECJ, FHIDFACHE, CBCDBIJAI, FHFJCEAIG, CFBCBJACG, FHGHHIJEC, CFCBGHFD...|[地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线...|[268034104, 268034105, 268034106, 268034104, 268034104, 268034105, 268034104, 268034106, 26803410...| 6631|2018-09-01|
| 白石洲|[2018-09-01 06:14:41, 2018-09-01 06:14:47, 2018-09-01 06:15:06, 2018-09-01 06:15:13, 2018-09-01 0...|[CBHBDBFCJ, FFIJBHCEJ, FHDJHEFFA, FHGGGJJCE, CFCBFAJFI, FFIABECAE, CFHCCHAAG, BIBEAICDI, FHEFJECH...|[地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线...|[268022113, 268022121, 268022119, 268022119, 268022121, 268022121, 268022121, 268022121, 26802212...| 6019|2018-09-01|
|   大芬|[2018-09-01 06:14:12, 2018-09-01 06:19:59, 2018-09-01 06:20:11, 2018-09-01 06:20:14, 2018-09-01 0...|[HHAAJBEID, FHFDDDECD, FFGEICDFD, FHEBCCEIG, FHJAAGBAA, CBFAIDIAD, FHGBBEJIE, FIABCGHGF, CCJFFDCG...|[地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线...|[261020101, 261020101, 261020101, 261020102, 261020101, 261020118, 261020102, 261020101, 26102010...| 5922|2018-09-01|
+-------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+-----+----------+
only showing top 10 rows

+------------+------+----------+
|company_name| count|       day|
+------------+------+----------+
|  地铁五号线|110020|2018-09-01|
|  地铁三号线| 91218|2018-09-01|
|  地铁一号线| 74798|2018-09-01|
|  地铁四号线| 53981|2018-09-01|
|  地铁七号线| 38420|2018-09-01|
|地铁十一号线| 33056|2018-09-01|
|  地铁二号线| 30786|2018-09-01|
|  地铁九号线| 27789|2018-09-01|
+------------+------+----------+

+----------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+-----+----------+
|   station|                                                                                       deal_date_arr|                                                                                         card_no_arr|                                                                                      deal_value_arr|                                                                                                                                                            company_name_arr|                                                                                       conn_mark_arr|                                                                                      deal_money_arr|                                                                                          equ_no_arr|count|       day|
+----------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+-----+----------+
|    深圳北|[2018-09-01 06:35:51, 2018-09-01 06:38:12, 2018-09-01 06:38:14, 2018-09-01 06:38:16, 2018-09-01 0...|[BJFHFGCD, CFADCHJFJ, FHEBCIEAG, FHHAIFGII, BIBBEIGBD, FFHECHBCF, FHGDJGIHE, CCACGIAFF, FHFBCBCFI...|[200, 200, 200, 200, 200, 200, 300, 200, 200, 200, 200, 300, 300, 200, 200, 200, 200, 200, 300, 2...|  [地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 1, 1, ...|[190, 190, 190, 190, 190, 190, 285, 190, 190, 190, 190, 285, 285, 190, 150, 190, 190, 190, 285, 1...|[263024122, 263024127, 263024125, 263024123, 263024120, 263024125, 263024126, 263024120, 26302412...| 8963|2018-09-01|
|    罗湖站|[2018-09-01 06:31:08, 2018-09-01 06:37:23, 2018-09-01 06:39:48, 2018-09-01 06:56:10, 2018-09-01 0...|[FHGBHIIDG, FHIBJBIHI, HHJJAIJEE, CGJJAFJCG, CGJJAFJCG, FFGCBEGCI, BIBIHIDIA, CCABCGBJA, FIJEAFDF...|[200, 200, 200, 200, 200, 200, 200, 200, 300, 300, 500, 500, 300, 200, 400, 500, 500, 400, 200, 3...|  [地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[190, 190, 0, 0, 0, 190, 190, 190, 285, 285, 0, 475, 245, 190, 380, 475, 0, 380, 190, 245, 190, 2...|[268001134, 268001129, 268001115, 268001122, 268001134, 268001105, 268001142, 268001143, 26800110...| 8894|2018-09-01|
|  福田口岸|[2018-09-01 06:38:33, 2018-09-01 06:38:37, 2018-09-01 06:38:40, 2018-09-01 06:38:44, 2018-09-01 0...|[FFEJACHHJ, HJDDJAAG, CCAFDBJAB, CBBACBDAF, FHGFFJCGB, CFCABAEED, CBJJBADEG, CFBHEFFEB, CCAFIJJAB...|[200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 2...|  [地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线, 地铁四号线...|[0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ...|[190, 190, 190, 190, 190, 190, 190, 150, 190, 190, 190, 190, 190, 190, 150, 190, 190, 190, 190, 1...|[268017120, 268017114, 268017101, 268017120, 268017116, 268017114, 268017119, 268017114, 26801712...| 6838|2018-09-01|
|会展中心站|[2018-09-01 06:39:56, 2018-09-01 06:45:47, 2018-09-01 06:46:10, 2018-09-01 06:46:14, 2018-09-01 0...|[CFHJFEBIA, CFCJCCGJA, FHIGIGFBD, CBEFHAGBD, FIJGJIHDF, CBEJDCCFF, FIJHCEDBD, FFGFAGIJC, BIABFBEA...|[200, 200, 200, 300, 200, 300, 300, 200, 200, 200, 200, 300, 200, 200, 200, 400, 200, 200, 200, 2...|  [地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线, 地铁一号线...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[190, 190, 190, 285, 190, 285, 285, 190, 190, 190, 190, 285, 190, 190, 190, 380, 190, 190, 190, 1...|[268008101, 268008128, 268008129, 268008111, 268008129, 268008125, 268008129, 268008126, 26800812...| 5841|2018-09-01|
|      老街|[2018-09-01 06:20:27, 2018-09-01 06:37:42, 2018-09-01 06:38:17, 2018-09-01 06:44:30, 2018-09-01 0...|[FIJHHEDJF, BIHHHCGHJ, FHHEJEHBD, FIAHDBAJI, FIACGCJIE, BCAFBCDB, BICJFGIGJ, CBDEFGADJ, HHAAJAAAH...|[200, 300, 200, 300, 400, 400, 200, 200, 200, 300, 400, 200, 200, 300, 200, 500, 200, 400, 400, 5...|  [地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ...|[190, 285, 190, 285, 380, 380, 190, 190, 0, 285, 380, 190, 190, 285, 190, 475, 190, 380, 380, 475...|[261012143, 261012110, 261012141, 261012153, 261012149, 261012109, 261012140, 261012141, 26101215...| 5696|2018-09-01|
|    华强北|[2018-09-01 06:37:56, 2018-09-01 06:43:28, 2018-09-01 06:47:03, 2018-09-01 06:47:16, 2018-09-01 0...|[FHHCEGAIH, FHEACCFEB, CBGACAJGB, FFGHBFAHI, CBHJFDBJF, FHIJDCHFF, CFJGHCBFJ, FHEADCDIJ, FHGADEHE...|[200, 200, 400, 300, 300, 300, 200, 300, 300, 300, 300, 300, 200, 200, 200, 500, 300, 500, 200, 2...|  [地铁二号线, 地铁二号线, 地铁七号线, 地铁二号线, 地铁二号线, 地铁二号线, 地铁二号线, 地铁二号线, 地铁二号线, 地铁七号线, 地铁二号线, 地铁二号线, 地铁二号线, 地铁七号线...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[190, 190, 380, 285, 285, 285, 190, 285, 285, 285, 285, 285, 190, 190, 0, 435, 285, 475, 190, 190...|[260034114, 260034116, 265030122, 260034120, 260034117, 260034117, 260034118, 260034120, 26003411...| 5683|2018-09-01|
|    南山站|[2018-09-01 06:17:24, 2018-09-01 06:17:50, 2018-09-01 06:18:46, 2018-09-01 06:18:50, 2018-09-01 0...|[HHAAACCJB, HHJJAEIGB, CFBJHADGI, CBFHFCIAC, CBHBIGABC, FFGDDIBGJ, FFIABGIGD, FIFBJBGIF, FHDDFGJF...|[200, 200, 200, 200, 200, 200, 200, 300, 400, 300, 500, 300, 500, 300, 200, 200, 300, 500, 500, 2...|[地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, 地铁十一号线, ...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[0, 0, 190, 190, 190, 190, 190, 285, 380, 285, 475, 285, 475, 285, 190, 190, 285, 475, 475, 0, 57...|[241015106, 241015105, 241015118, 241015116, 241015115, 241015119, 241015127, 241015116, 24101512...| 5424|2018-09-01|
|      兴东|[2018-09-01 06:31:40, 2018-09-01 06:36:46, 2018-09-01 06:38:23, 2018-09-01 06:38:59, 2018-09-01 0...|[HHJJAEIFJ, HHAAABFDC, FHFEFHJFG, AHJJBDGCB, FHFEIFFFA, FHIHIGDBC, FIJIFCGCI, FHHCIEBEE, FFAECDDG...|[200, 200, 200, 200, 200, 200, 200, 200, 200, 300, 200, 200, 200, 200, 200, 200, 200, 200, 200, 2...|  [地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线...|[0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[0, 0, 190, 190, 190, 190, 190, 150, 190, 285, 190, 190, 190, 190, 190, 190, 190, 190, 190, 190, ...|[263018108, 263018114, 263018112, 263018103, 263018106, 263018102, 263018101, 263018101, 26301810...| 5334|2018-09-01|
|      五和|[2018-09-01 06:18:21, 2018-09-01 06:18:36, 2018-09-01 06:34:32, 2018-09-01 06:35:40, 2018-09-01 0...|[DDABFIAIA, HHAAAAJAC, FIJGHCFJF, FHDIGEIHJ, CBFEFDEEG, BICEDHEJC, FFFDJDJII, CBJHFAJHH, FIJBHCHF...|[200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 300, 300, 200, 300, 300, 3...|  [地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线, 地铁五号线...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ...|[190, 0, 190, 190, 190, 190, 190, 190, 190, 190, 100, 190, 190, 190, 285, 285, 190, 245, 285, 285...|[263026103, 263026101, 263026106, 263026108, 263026101, 263026102, 263026101, 263026102, 26302611...| 5058|2018-09-01|
|      福田|[2018-09-01 06:35:50, 2018-09-01 06:36:09, 2018-09-01 06:36:23, 2018-09-01 06:36:34, 2018-09-01 0...|[CCADDJFCI, FIJAAGGCG, BIJJHGDDD, CCJGICHBH, FHDHCDHDF, CBCCEFGGC, FFEBJGCJB, CBCDJJACA, FFEDDEHA...|[200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 200, 3...|  [地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线, 地铁三号线...|[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, ...|[190, 190, 190, 190, 190, 190, 190, 190, 190, 190, 190, 190, 190, 0, 190, 190, 190, 190, 190, 285...|[261006132, 261006110, 261006109, 261006108, 261006108, 261006128, 261006109, 261006167, 26100616...| 5019|2018-09-01|
+----------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------+-----+----------+
only showing top 10 rows

*/